<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 3.2//EN">

<html>
<head>

  <title>Access MDB databases</title>
</head>

<body bgcolor="#FFFFFF">
  <h1>Access MDB databases</h1>

  <p>GDAL/OGR >= 1.9.0</p>

  <p>OGR optionally supports reading access .mdb
  files by using the Java <a href="http://jackcess.sourceforge.net/">Jackcess</a> library.</p>

  <p>This driver is primarly meant as being used on Unix platforms to overcome the
     issues often met with the MDBTools library that acts as the ODBC driver for MDB databases.</p>

  <p>The driver can detect ESRI Personal Geodatabases and Geomedia MDB databases, and will
     deal them exactly as the <a href="drv_pgeo.html">PGeo</a> and
     <a href="drv_geomedia.html">Geomedia</a> drivers do. For other MDB databases, all the tables
     will be presented as OGR layers.</p>

  <h2>How to build the MDB driver (on Linux)</h2>

  You need a JDK (a JRE is not enough) to build the driver.

  On Ubuntu 10.04 with the openjdk-6-jdk package installed,

  <pre>./configure --with-java=yes --with-mdb=yes</pre>

  On others Linux flavours, you may need to specify :

  <pre>./configure --with-java=/path/to/jdk/root/path --with-jvm-lib=/path/to/libjvm/directory --with-mdb=yes</pre>

  where /path/to/libjvm/directory is for example /usr/lib/jvm/java-6-openjdk/jre/lib/amd64/server <p>

  It is possible to add the <i>--with-jvm-lib-add-rpath</i> option (no value or "yes") to embed the path
  to the libjvm.so in the GDAL library.<p>

  <h2>How to run the MDB driver (on Linux)</h2>

  You need a JRE and 3 external JARs to run the driver.

  <ol>
  <li>If you didn't specify --with-jvm-lib-add-rpath at configure time, set the path of the directory that contains libjvm.so in LD_LIBRARY_PATH or in /etc/ld.so.conf.</li>
  <li>Download jackcess-1.2.2.jar, commons-lang-2.4.jar and commons-logging-1.1.1.jar (other versions might work)</li>
  <li>Put the 3 JARs either in the lib/ext directory of the JRE (e.g. /usr/lib/jvm/java-6-openjdk/jre/lib/ext) or in another directory
  and explicitely point them with the CLASSPATH environment variable.</li>
  </ol>

  <h2>Resources</h2>

  <ul>
  <li><a href="http://jackcess.sourceforge.net/">Jackcess</a> library home page</li>
  <li>Utility that contains the needed <a href="http://mdb-sqlite.googlecode.com/files/mdb-sqlite-1.0.2.tar.bz2">JARs dependencies</a></lib>
  </ul>

  <h2>See also</h2>

  <ul>
  <li><a href="drv_pgeo.html">PGeo</a> driver page</li>
  <li><a href="drv_geomedia.html">Geomedia</a> driver page</li>
  </ul>

</body>
</html>

